﻿#ifndef HOME_H
#define HOME_H

#include <QWidget>
#include <QAxObject>

namespace Ui {
class Home;
}

class Home : public QWidget
{
    Q_OBJECT

public:
    explicit Home(QWidget *parent = 0);
    ~Home();
    QVariantList getExcelData();//从Excel中读取数据
    void loadExcelDataToDataBase(QVariantList);//将读到的数据存到数据库中
    bool createDateBaseConnection();//创建一个数据库连接
    bool createTable(QString);
    bool insertData(QVariantList, QString);
    bool queryById(QString);
    void init();//初始化各项参数

private slots:
    void on_pushButton_0_clicked();

    void on_pushButton_1_clicked();

private:
    Ui::Home *ui;
};

#endif // HOME_H
